package cn.biplam.common.struc;


/**
 * 系统管理表结构
 * @author XiaoRuxing Sep 24, 20092:30:50 PM
 * @version 1.0
 */
public abstract class SysStruc {

	/**
	 * 任务表结构
	 * Task
	 */
	public static class TaskStruc {
		/** 任务id*/
		public static final String TASK_ID = "task_id";
		/** 任务描述*/
		public static final String TASK_DESC = "task_desc";
		/** 模型类型*/
		public static final String MODEL_TYPE = "model_type";
		/** 模型主题*/
		public static final String MODEL_THEME = "model_theme";
		/** 任务状态*/
		public static final String STATUS = "status";
		/** 开始时间*/
		public static final String START_TIME = "start_time";
		/** 结束时间*/
		public static final String END_TIME = "end_time";
		/** 任务类型*/
		public static final String TASK_TYPE = "task_type";
	}

	/**
	 * 用户表表结构
	 * users
	 */
	public static class UserStruc{
		public static final String USERID = "userid";
		public static final String USERNAME = "username";
		public static final String USERCODE = "usercode";
		public static final String PASSWORD = "password";
		public static final String SEX = "sex";
		public static final String BIRTHEDAY = "bithday";
		/** 语言类型*/
		public static final String LANG="userlanguage";
		public static final String USER_MACHINE = "machine_name";
	}
	
	/**
	 * 用户索引表表结构
	 */
	public static class UserIndexStruc{
		/** 表名 */
		public static final String Table_Name = "USERS_INDEX";
	}
	
	/**
	 * 用户角色表表结构
	 */
	public static class UserRoleStruc{
		/** 表名 */
		public static final String Table_Name = "USER_ROLE";
		/** 用户角色ID */
		public static final String USER_ROLE_ID = "U_R_ID";
		/** 用户ID */
		public static final String USER_ID = "USER_ID";
		/** 角色ID */
		public static final String ROLE_ID = "ROLE_ID";
	}
	
	/**
	 * 用户权限表表结构
	 */
	public static class UserPriviStruc{
		/** 表名 */
		public static final String Table_Name = "USER_PRIVI";
		/** 用户权限ID */
		public static final String USER_PRIVI_ID = "USP_ID";
		/** 用户ID */
		public static final String USER_ID = "USER_ID";
		/** 权限ID */
		public static final String PRIVI_ID = "PRIVI_ID";
	}
	
	/**
	 * 角色索引表表结构
	 */
	public static class RoleIndexStruc{
		/** 表名 */
		public static final String Table_Name = "ROLE";
		/** 角色ID */
		public static final String Role_ID = "NODE_ID";
		/** 角色名称 */
		public static final String Role_Name = "NODE_NAME";
		/** 角色描述 */
		public static final String Role_Desc = "NODE_DESC";
	}
	
	/**
	 * 角色权限表表结构
	 */
	public static class RolePriviStruc{
		/** 表名 */
		public static final String Table_Name = "ROLE_PRIVI";
		/** 角色ID */
		public static final String ID = "ROP_ID";
		/** 权限ID */
		public static final String PRIVI_ID = "PRIVI_ID";
		/** 角色ID */
		public static final String ROLE_ID = "ROLE_ID";
		/** 完全拥有权限标志
		 * 0:非完全拥有 (拥有部分下级权限)
		 * 1:完全拥有（拥有当前权限及其所有下级权限）
		 *  */
		public static final String SUPPER_FLAG = "SUPPER_FLAG";
	}
	
	/**
	 * 角色拥有权限类型标志
	 * 
	 */
	public enum Role_Privi_Flag{
		/** 非完全拥有 (拥有部分下级权限) */
		NORMAL("0"),
		/** 完全拥有（拥有当前权限及其所有下级权限） */
		SUPPER("1");
		private String value;
		private Role_Privi_Flag(String value){this.value=value;}
		public String toString() {return value;}
	}
	
	/**
	 * 权限发布表表结构
	 */
	public static class PriviDeployStruc{
		/** 表名称 */
		public static final String Table_Name = "PRIVI_DEPLOY";
		/** 主键 */
		public static final String DEPLOY_ID = "DEPLOY_ID";
		/** 名称 */
		public static final String NAME = "D_NAME";
		/** 描述 */
		public static final String DESC = "D_DESC";
		/** 权限管理入口Action */
		public static final String SHOW_ACT_ID = "SHOW_ACT_ID";
		/** 排序 */
		public static final String SEQ = "SEQ";
		/** 虚根ID */
		public static final String VIRTUAL_ROOT_ID = "VIRTUAL_ROOT_ID";
		/** 根节点ID */
		public static final String ROOT_ID = "ROOT_ID";
	}
	
	/**
	 * 权限表表结果
	 */
	public static class PriviStruc{
		public static final String Table_Name = "PRIVI";
		/** 权限ID */
		public static final String PRIVI_ID = "NODE_ID";
		/** 权限ID */
		public static final String PRIVI_NAME = "NODE_NAME";
		/** 权限描述 */
		public static final String PRIVI_DESC = "NODE_DESC";
		/** 权限父亲 */
		public static final String PRIVI_PARENT = "NODE_PARENT";
	}
	
	/**
	 * 系统菜单表表结构
	 */
	public static class MenuStruc{
		/** 表名称  */
		public static final String Table_Name = "MENU";
		/** 菜单ID */
		public static final String MENU_ID = "MENU_ID";
		/** 父菜单ID */
		public static final String MENU_PARENT = "MENU_PARENT";
		/** 菜单名称 */
		public static final String MENU_NAME = "MENU_NAME";
		/** 菜单描述 */
		public static final String MENU_DESC = "MENU_DESC";
		/** 菜单排序 */
		public static final String MENU_SEQUENCE = "MENU_SEQUENCE";
		/** 菜单图片路径 */
		public static final String PIC_PATH = "PIC";
		/** 菜单跳转动作ID */
		public static final String ACTION_ID = "ACTIONID";
	}
	
	/**
	 * File_DownLoad表表结构
	 */
	public static class FileDownLoadStru {
		/** 文件名 */
		public static final String FILE_NAME="FILE_NAME";
		/** 文件路径 */
		public static final String FILE_PATH="FILE_PATH";
		/** 上传用户 */
		public static final String UPLOAD_USER="UPLOAD_USER";
		/** 上传日期 */
		public static final String UPLOAD_DATE="UPLOAD_DATE";
		/** 上传时间 */
		public static final String UPLOAD_TIME="UPLOAD_TIME";
	}
	
	/**
	 * FILE_UPLOAD表结构
	 */
	public interface FileUpLoadStru {
		public static final String FILE_ID="FILE_ID";
		public static final String FILE_NAME="FILE_NAME";
		public static final String FILE_PATH="FILE_PATH";
		public static final String UPLOAD_USER="UPLOAD_USER";
		public static final String UPLOAD_DATE="UPLOAD_DATE";
		public static final String UPLOAD_TIME="UPLOAD_TIME";
	}

	/**
	 * 系统参数表结构
	 * Sys_Param
	 */
	public static class SysParam{
		/** 参数ID(即参数key名称)*/
		public static final String Param_ID="Param_ID";
		/** 参数名称(描述名称) */
		public static final String Param_Name="Param_Name";
		/** 参数默认值 */
		public static final String Default_Value="Default_Value";
		/** 参数应用值 */
		public static final String Apply_Value="Apply_Value";
		/** 参数类型ID */
		public static final String Param_Type_Id="Param_Type_Id";
	}
}
